package com.sn.pw.dao.entity;

import com.baomidou.mybatisplus.annotation.TableName;
import com.baomidou.mybatisplus.annotation.TableField;
import com.gitee.sunchenbin.mybatis.actable.constants.MySqlCharsetConstant;
import com.gitee.sunchenbin.mybatis.actable.constants.MySqlEngineConstant;
import com.gitee.sunchenbin.mybatis.actable.constants.MySqlTypeConstant;
import com.sn.pw.common.entity.BaseEntity;
import lombok.Data;

import com.gitee.sunchenbin.mybatis.actable.annotation.*;

@Data
@TableName("evaluation")
@TableComment("评价表")
@TableCharset(MySqlCharsetConstant.UTF8MB4)
@TableEngine(MySqlEngineConstant.InnoDB)
public class Evaluation extends BaseEntity {
    /**
     * 物流公司id
     */
    @TableField("logistics_company_id")
    @ColumnType(MySqlTypeConstant.BIGINT)
    @ColumnComment("物流公司ID")
    private Long companyId;

    /**
     * 出通订单id
     */
    @TableField("shipping_order_number")
    @ColumnType(MySqlTypeConstant.VARCHAR)
    @ColumnComment("出通单号")
    private String shippingOrderNumber;

    /**
     * 评价人id
     */
    @TableField("evaluator_id")
    @ColumnType(MySqlTypeConstant.BIGINT)
    @ColumnComment("评价人ID")
    private Long evaluatorId;

    /**
     * 总分评价分数
     */
    @TableField("overall_score")
    @ColumnType(MySqlTypeConstant.INT)
    @ColumnComment("总分评价分数")
    private Integer overallScore;

    /**
     * 时效评分
     */
    @TableField("timeliness_score")
    @ColumnType(MySqlTypeConstant.INT)
    @ColumnComment("时效评分")
    private Integer timelinessScore;

    /**
     * 服务评分
     */
    @TableField("service_score")
    @ColumnType(MySqlTypeConstant.INT)
    @ColumnComment("服务评分")
    private Integer serviceScore;

    /**
     * 专业评分
     */
    @TableField("professional_score")
    @ColumnType(MySqlTypeConstant.INT)
    @ColumnComment("专业评分")
    private Integer professionalScore;

    /**
     * 评价内容
     */
    @TableField("comment_content")
    @ColumnType(MySqlTypeConstant.TEXT)
    @ColumnComment("评价内容")
    private String commentContent;
}